﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ContabilidadDataSet" targetNamespace="http://tempuri.org/ContabilidadDataSet.xsd" xmlns:mstns="http://tempuri.org/ContabilidadDataSet.xsd" xmlns="http://tempuri.org/ContabilidadDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ContabilidadConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ContabilidadConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ModuloDeInventario.Properties.Settings.GlobalReference.Default.ContabilidadConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DevolucionesTableAdapter" GeneratorDataComponentClassName="DevolucionesTableAdapter" Name="Devoluciones" UserDataComponentName="DevolucionesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Devoluciones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Devoluciones] ([NumeroDeFactura], [CodigoDelProducto], [Cantidad], [MotivoDeLaDevolucion], [Fecha]) VALUES (@NumeroDeFactura, @CodigoDelProducto, @Cantidad, @MotivoDeLaDevolucion, @Fecha)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumeroDeFactura" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumeroDeFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDelProducto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cantidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MotivoDeLaDevolucion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MotivoDeLaDevolucion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NumeroDeFactura, CodigoDelProducto, Cantidad, MotivoDeLaDevolucion, Fecha FROM dbo.Devoluciones</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NumeroDeFactura" DataSetColumn="NumeroDeFactura" />
              <Mapping SourceColumn="CodigoDelProducto" DataSetColumn="CodigoDelProducto" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
              <Mapping SourceColumn="MotivoDeLaDevolucion" DataSetColumn="MotivoDeLaDevolucion" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Devoluciones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NumeroDeFactura, CodigoDelProducto, Cantidad, MotivoDeLaDevolucion, Fecha FROM dbo.Devoluciones</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EntradasTableAdapter" GeneratorDataComponentClassName="EntradasTableAdapter" Name="Entradas" UserDataComponentName="EntradasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Entradas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Entradas] ([Conduce], [CodigoDelProducto], [Cantidad], [PrecioTotal], [PrecioPorUnidad], [Fecha]) VALUES (@Conduce, @CodigoDelProducto, @Cantidad, @PrecioTotal, @PrecioPorUnidad, @Fecha)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Conduce" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Conduce" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDelProducto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cantidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@PrecioTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="PrecioTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@PrecioPorUnidad" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="PrecioPorUnidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Conduce, CodigoDelProducto, Cantidad, PrecioTotal, PrecioPorUnidad, Fecha FROM dbo.Entradas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Conduce" DataSetColumn="Conduce" />
              <Mapping SourceColumn="CodigoDelProducto" DataSetColumn="CodigoDelProducto" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
              <Mapping SourceColumn="PrecioTotal" DataSetColumn="PrecioTotal" />
              <Mapping SourceColumn="PrecioPorUnidad" DataSetColumn="PrecioPorUnidad" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Entradas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Conduce, CodigoDelProducto, Cantidad, PrecioTotal, PrecioPorUnidad, Fecha FROM dbo.Entradas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FacturasTableAdapter" GeneratorDataComponentClassName="FacturasTableAdapter" Name="Facturas" UserDataComponentName="FacturasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Facturas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Facturas] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Facturas] ([NumeroFactura], [CodigoCliente], [Monto], [Fecha]) VALUES (@NumeroFactura, @CodigoCliente, @Monto, @Fecha);
SELECT NumeroFactura, CodigoCliente, Monto, Fecha FROM Facturas WHERE (NumeroFactura = @NumeroFactura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumeroFactura" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumeroFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CodigoCliente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CodigoCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Monto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Monto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id FROM Facturas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Facturas] SET [NumeroFactura] = @NumeroFactura, [CodigoCliente] = @CodigoCliente, [Monto] = @Monto, [Fecha] = @Fecha WHERE (([NumeroFactura] = @Original_NumeroFactura) AND ([CodigoCliente] = @Original_CodigoCliente) AND ([Monto] = @Original_Monto) AND ([Fecha] = @Original_Fecha));
SELECT NumeroFactura, CodigoCliente, Monto, Fecha FROM Facturas WHERE (NumeroFactura = @NumeroFactura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumeroFactura" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumeroFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CodigoCliente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CodigoCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Monto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Monto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumeroFactura" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumeroFactura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CodigoCliente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CodigoCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Monto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Monto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LineaDeProductosTableAdapter" GeneratorDataComponentClassName="LineaDeProductosTableAdapter" Name="LineaDeProductos" UserDataComponentName="LineaDeProductosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.LineaDeProductos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[LineaDeProductos] WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([Descripcion] = @Original_Descripcion))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[LineaDeProductos] ([Codigo], [Nombre], [Descripcion]) VALUES (@Codigo, @Nombre, @Descripcion);
SELECT Codigo, Nombre, Descripcion FROM LineaDeProductos WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, Descripcion FROM dbo.LineaDeProductos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[LineaDeProductos] SET [Codigo] = @Codigo, [Nombre] = @Nombre, [Descripcion] = @Descripcion WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([Descripcion] = @Original_Descripcion));
SELECT Codigo, Nombre, Descripcion FROM LineaDeProductos WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.LineaDeProductos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorCodigo" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorCodigo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="PorCodigo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, Descripcion
FROM            LineaDeProductos
WHERE        (Codigo = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Codigo" DataSourceName="Contabilidad.dbo.LineaDeProductos" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.LineaDeProductos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorNombre" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorNombre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="PorNombre">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, Descripcion
FROM            LineaDeProductos
WHERE        (Nombre = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Nombre" DataSourceName="Contabilidad.dbo.LineaDeProductos" DataTypeServer="nchar(40)" DbType="String" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="NChar" Scale="0" Size="40" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.LineaDeProductos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, Descripcion
FROM            LineaDeProductos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.LineaDeProductos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos1" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="Todos1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, Descripcion FROM dbo.LineaDeProductos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductosTableAdapter" GeneratorDataComponentClassName="ProductosTableAdapter" Name="Productos" UserDataComponentName="ProductosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Productos] WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([CantidadEnExistencia] = @Original_CantidadEnExistencia) AND ([Minimo] = @Original_Minimo) AND ([Maximo] = @Original_Maximo) AND ([PrecioPorUnidad] = @Original_PrecioPorUnidad) AND ([CodigoDeLaLinea] = @Original_CodigoDeLaLinea) AND ([CodigoDelProveedor] = @Original_CodigoDelProveedor) AND ([Descripcion] = @Original_Descripcion))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CantidadEnExistencia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CantidadEnExistencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Minimo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Minimo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Maximo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Maximo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PrecioPorUnidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="PrecioPorUnidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodigoDeLaLinea" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDeLaLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodigoDelProveedor" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProveedor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Productos] ([Codigo], [Nombre], [CantidadEnExistencia], [Minimo], [Maximo], [PrecioPorUnidad], [CodigoDeLaLinea], [CodigoDelProveedor], [Descripcion]) VALUES (@Codigo, @Nombre, @CantidadEnExistencia, @Minimo, @Maximo, @PrecioPorUnidad, @CodigoDeLaLinea, @CodigoDelProveedor, @Descripcion);
SELECT Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion FROM Productos WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CantidadEnExistencia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CantidadEnExistencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Minimo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Minimo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Maximo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Maximo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PrecioPorUnidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="PrecioPorUnidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDeLaLinea" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDeLaLinea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDelProveedor" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProveedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion FROM dbo.Productos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Productos] SET [Codigo] = @Codigo, [Nombre] = @Nombre, [CantidadEnExistencia] = @CantidadEnExistencia, [Minimo] = @Minimo, [Maximo] = @Maximo, [PrecioPorUnidad] = @PrecioPorUnidad, [CodigoDeLaLinea] = @CodigoDeLaLinea, [CodigoDelProveedor] = @CodigoDelProveedor, [Descripcion] = @Descripcion WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([CantidadEnExistencia] = @Original_CantidadEnExistencia) AND ([Minimo] = @Original_Minimo) AND ([Maximo] = @Original_Maximo) AND ([PrecioPorUnidad] = @Original_PrecioPorUnidad) AND ([CodigoDeLaLinea] = @Original_CodigoDeLaLinea) AND ([CodigoDelProveedor] = @Original_CodigoDelProveedor) AND ([Descripcion] = @Original_Descripcion));
SELECT Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion FROM Productos WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CantidadEnExistencia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CantidadEnExistencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Minimo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Minimo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Maximo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Maximo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PrecioPorUnidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="PrecioPorUnidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDeLaLinea" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDeLaLinea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDelProveedor" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProveedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CantidadEnExistencia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CantidadEnExistencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Minimo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Minimo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Maximo" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Maximo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PrecioPorUnidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="PrecioPorUnidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodigoDeLaLinea" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDeLaLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CodigoDelProveedor" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProveedor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="CantidadEnExistencia" DataSetColumn="CantidadEnExistencia" />
              <Mapping SourceColumn="Minimo" DataSetColumn="Minimo" />
              <Mapping SourceColumn="Maximo" DataSetColumn="Maximo" />
              <Mapping SourceColumn="PrecioPorUnidad" DataSetColumn="PrecioPorUnidad" />
              <Mapping SourceColumn="CodigoDeLaLinea" DataSetColumn="CodigoDeLaLinea" />
              <Mapping SourceColumn="CodigoDelProveedor" DataSetColumn="CodigoDelProveedor" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorCodigo" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorCodigo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="PorCodigo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion
FROM            Productos
WHERE        (Codigo = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Codigo" DataSourceName="Contabilidad.dbo.Productos" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorNombre" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorNombre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="PorNombre">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion
FROM            Productos
WHERE        (Nombre = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Nombre" DataSourceName="Contabilidad.dbo.Productos" DataTypeServer="nchar(40)" DbType="String" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="NChar" Scale="0" Size="40" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, CantidadEnExistencia, Minimo, Maximo, PrecioPorUnidad, CodigoDeLaLinea, CodigoDelProveedor, Descripcion FROM dbo.Productos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProveedoresTableAdapter" GeneratorDataComponentClassName="ProveedoresTableAdapter" Name="Proveedores" UserDataComponentName="ProveedoresTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Proveedores" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Proveedores] WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([Telefono] = @Original_Telefono) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ([E_Mail] = @Original_E_Mail) AND ([Contacto] = @Original_Contacto))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefono" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_E_Mail" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="E_Mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Contacto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Proveedores] ([Codigo], [Nombre], [Telefono], [Fax], [E_Mail], [Contacto]) VALUES (@Codigo, @Nombre, @Telefono, @Fax, @E_Mail, @Contacto);
SELECT Codigo, Nombre, Telefono, Fax, E_Mail, Contacto FROM Proveedores WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefono" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@E_Mail" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="E_Mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Contacto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, Telefono, Fax, E_Mail, Contacto FROM dbo.Proveedores</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Proveedores] SET [Codigo] = @Codigo, [Nombre] = @Nombre, [Telefono] = @Telefono, [Fax] = @Fax, [E_Mail] = @E_Mail, [Contacto] = @Contacto WHERE (([Codigo] = @Original_Codigo) AND ([Nombre] = @Original_Nombre) AND ([Telefono] = @Original_Telefono) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ([E_Mail] = @Original_E_Mail) AND ([Contacto] = @Original_Contacto));
SELECT Codigo, Nombre, Telefono, Fax, E_Mail, Contacto FROM Proveedores WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefono" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@E_Mail" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="E_Mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Contacto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefono" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_E_Mail" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="E_Mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Contacto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Telefono" DataSetColumn="Telefono" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="E_Mail" DataSetColumn="E_Mail" />
              <Mapping SourceColumn="Contacto" DataSetColumn="Contacto" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Proveedores" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorCodigo" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorCodigo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="PorCodigo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, Telefono, Fax, E_Mail, Contacto
FROM            Proveedores
WHERE        (Codigo = @Param3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="Codigo" DataSourceName="Contabilidad.dbo.Proveedores" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Param3" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Proveedores" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="PorNombre" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="PorNombre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="PorNombre">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Codigo, Nombre, Telefono, Fax, E_Mail, Contacto
FROM            Proveedores
WHERE        (Nombre = @Param1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Nombre" DataSourceName="Contabilidad.dbo.Proveedores" DataTypeServer="nchar(40)" DbType="String" Direction="Input" ParameterName="@Param1" Precision="0" ProviderType="NChar" Scale="0" Size="40" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Proveedores" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre, Telefono, Fax, E_Mail, Contacto FROM dbo.Proveedores</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalidasTableAdapter" GeneratorDataComponentClassName="SalidasTableAdapter" Name="Salidas" UserDataComponentName="SalidasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Salidas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Salidas] ([NumeroDeFactura], [CodigoDelProducto], [Cantidad], [Fecha]) VALUES (@NumeroDeFactura, @CodigoDelProducto, @Cantidad, @Fecha)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumeroDeFactura" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumeroDeFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CodigoDelProducto" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CodigoDelProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cantidad" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NumeroDeFactura, CodigoDelProducto, Cantidad, Fecha FROM dbo.Salidas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NumeroDeFactura" DataSetColumn="NumeroDeFactura" />
              <Mapping SourceColumn="CodigoDelProducto" DataSetColumn="CodigoDelProducto" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Salidas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Todos" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Todos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Todos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NumeroDeFactura, CodigoDelProducto, Cantidad, Fecha FROM dbo.Salidas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuariosTableAdapter" GeneratorDataComponentClassName="UsuariosTableAdapter" Name="Usuarios" UserDataComponentName="UsuariosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.Usuarios" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Usuarios] WHERE (([Usuario] = @Original_Usuario) AND ([Contraseña] = @Original_Contraseña) AND ([Modulo] = @Original_Modulo) AND ([Privilegio] = @Original_Privilegio))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Usuario" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contraseña" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contraseña" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Usuarios] ([Usuario], [Contraseña], [Modulo], [Privilegio]) VALUES (@Usuario, @Contraseña, @Modulo, @Privilegio);
SELECT Usuario, Contraseña, Modulo, Privilegio FROM Usuarios WHERE (Usuario = @Usuario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Usuario" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contraseña" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contraseña" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Usuario, Contraseña, Modulo, Privilegio FROM dbo.Usuarios</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Usuarios] SET [Usuario] = @Usuario, [Contraseña] = @Contraseña, [Modulo] = @Modulo, [Privilegio] = @Privilegio WHERE (([Usuario] = @Original_Usuario) AND ([Contraseña] = @Original_Contraseña) AND ([Modulo] = @Original_Modulo) AND ([Privilegio] = @Original_Privilegio));
SELECT Usuario, Contraseña, Modulo, Privilegio FROM Usuarios WHERE (Usuario = @Usuario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Usuario" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contraseña" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contraseña" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Usuario" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contraseña" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contraseña" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Usuario" DataSetColumn="Usuario" />
              <Mapping SourceColumn="Contraseña" DataSetColumn="Contraseña" />
              <Mapping SourceColumn="Modulo" DataSetColumn="Modulo" />
              <Mapping SourceColumn="Privilegio" DataSetColumn="Privilegio" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuarioMTableAdapter" GeneratorDataComponentClassName="UsuarioMTableAdapter" Name="UsuarioM" UserDataComponentName="UsuarioMTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.UsuarioM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UsuarioM] WHERE (([Modulo] = @Original_Modulo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UsuarioM] ([Modulo]) VALUES (@Modulo);
SELECT Modulo FROM UsuarioM WHERE (Modulo = @Modulo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Modulo FROM dbo.UsuarioM</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UsuarioM] SET [Modulo] = @Modulo WHERE (([Modulo] = @Original_Modulo));
SELECT Modulo FROM UsuarioM WHERE (Modulo = @Modulo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Modulo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Modulo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Modulo" DataSetColumn="Modulo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuarioPTableAdapter" GeneratorDataComponentClassName="UsuarioPTableAdapter" Name="UsuarioP" UserDataComponentName="UsuarioPTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ContabilidadConnectionString (Settings)" DbObjectName="Contabilidad.dbo.UsuarioP" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UsuarioP] WHERE (([Privilegio] = @Original_Privilegio))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UsuarioP] ([Privilegio]) VALUES (@Privilegio);
SELECT Privilegio FROM UsuarioP WHERE (Privilegio = @Privilegio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Privilegio FROM dbo.UsuarioP</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UsuarioP] SET [Privilegio] = @Privilegio WHERE (([Privilegio] = @Original_Privilegio));
SELECT Privilegio FROM UsuarioP WHERE (Privilegio = @Privilegio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Privilegio" DataSetColumn="Privilegio" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ContabilidadDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ContabilidadDataSet" msprop:Generator_UserDSName="ContabilidadDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Devoluciones" msprop:Generator_TableClassName="DevolucionesDataTable" msprop:Generator_TableVarName="tableDevoluciones" msprop:Generator_TablePropName="Devoluciones" msprop:Generator_RowDeletingName="DevolucionesRowDeleting" msprop:Generator_UserTableName="Devoluciones" msprop:Generator_RowChangingName="DevolucionesRowChanging" msprop:Generator_RowEvHandlerName="DevolucionesRowChangeEventHandler" msprop:Generator_RowDeletedName="DevolucionesRowDeleted" msprop:Generator_RowEvArgName="DevolucionesRowChangeEvent" msprop:Generator_RowChangedName="DevolucionesRowChanged" msprop:Generator_RowClassName="DevolucionesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NumeroDeFactura" msprop:Generator_ColumnVarNameInTable="columnNumeroDeFactura" msprop:Generator_ColumnPropNameInRow="NumeroDeFactura" msprop:Generator_ColumnPropNameInTable="NumeroDeFacturaColumn" msprop:Generator_UserColumnName="NumeroDeFactura" type="xs:decimal" />
              <xs:element name="CodigoDelProducto" msprop:Generator_ColumnVarNameInTable="columnCodigoDelProducto" msprop:Generator_ColumnPropNameInRow="CodigoDelProducto" msprop:Generator_ColumnPropNameInTable="CodigoDelProductoColumn" msprop:Generator_UserColumnName="CodigoDelProducto">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:decimal" />
              <xs:element name="MotivoDeLaDevolucion" msprop:Generator_ColumnVarNameInTable="columnMotivoDeLaDevolucion" msprop:Generator_ColumnPropNameInRow="MotivoDeLaDevolucion" msprop:Generator_ColumnPropNameInTable="MotivoDeLaDevolucionColumn" msprop:Generator_UserColumnName="MotivoDeLaDevolucion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Entradas" msprop:Generator_TableClassName="EntradasDataTable" msprop:Generator_TableVarName="tableEntradas" msprop:Generator_TablePropName="Entradas" msprop:Generator_RowDeletingName="EntradasRowDeleting" msprop:Generator_UserTableName="Entradas" msprop:Generator_RowChangingName="EntradasRowChanging" msprop:Generator_RowEvHandlerName="EntradasRowChangeEventHandler" msprop:Generator_RowDeletedName="EntradasRowDeleted" msprop:Generator_RowEvArgName="EntradasRowChangeEvent" msprop:Generator_RowChangedName="EntradasRowChanged" msprop:Generator_RowClassName="EntradasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Conduce" msprop:Generator_ColumnVarNameInTable="columnConduce" msprop:Generator_ColumnPropNameInRow="Conduce" msprop:Generator_ColumnPropNameInTable="ConduceColumn" msprop:Generator_UserColumnName="Conduce" type="xs:decimal" />
              <xs:element name="CodigoDelProducto" msprop:Generator_ColumnVarNameInTable="columnCodigoDelProducto" msprop:Generator_ColumnPropNameInRow="CodigoDelProducto" msprop:Generator_ColumnPropNameInTable="CodigoDelProductoColumn" msprop:Generator_UserColumnName="CodigoDelProducto">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:decimal" />
              <xs:element name="PrecioTotal" msprop:Generator_ColumnVarNameInTable="columnPrecioTotal" msprop:Generator_ColumnPropNameInRow="PrecioTotal" msprop:Generator_ColumnPropNameInTable="PrecioTotalColumn" msprop:Generator_UserColumnName="PrecioTotal" type="xs:decimal" />
              <xs:element name="PrecioPorUnidad" msprop:Generator_ColumnVarNameInTable="columnPrecioPorUnidad" msprop:Generator_ColumnPropNameInRow="PrecioPorUnidad" msprop:Generator_ColumnPropNameInTable="PrecioPorUnidadColumn" msprop:Generator_UserColumnName="PrecioPorUnidad" type="xs:decimal" />
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Facturas" msprop:Generator_TableClassName="FacturasDataTable" msprop:Generator_TableVarName="tableFacturas" msprop:Generator_TablePropName="Facturas" msprop:Generator_RowDeletingName="FacturasRowDeleting" msprop:Generator_UserTableName="Facturas" msprop:Generator_RowChangingName="FacturasRowChanging" msprop:Generator_RowEvHandlerName="FacturasRowChangeEventHandler" msprop:Generator_RowDeletedName="FacturasRowDeleted" msprop:Generator_RowEvArgName="FacturasRowChangeEvent" msprop:Generator_RowChangedName="FacturasRowChanged" msprop:Generator_RowClassName="FacturasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LineaDeProductos" msprop:Generator_TableClassName="LineaDeProductosDataTable" msprop:Generator_TableVarName="tableLineaDeProductos" msprop:Generator_TablePropName="LineaDeProductos" msprop:Generator_RowDeletingName="LineaDeProductosRowDeleting" msprop:Generator_UserTableName="LineaDeProductos" msprop:Generator_RowChangingName="LineaDeProductosRowChanging" msprop:Generator_RowEvHandlerName="LineaDeProductosRowChangeEventHandler" msprop:Generator_RowDeletedName="LineaDeProductosRowDeleted" msprop:Generator_RowEvArgName="LineaDeProductosRowChangeEvent" msprop:Generator_RowChangedName="LineaDeProductosRowChanged" msprop:Generator_RowClassName="LineaDeProductosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Productos" msprop:Generator_TableClassName="ProductosDataTable" msprop:Generator_TableVarName="tableProductos" msprop:Generator_TablePropName="Productos" msprop:Generator_RowDeletingName="ProductosRowDeleting" msprop:Generator_UserTableName="Productos" msprop:Generator_RowChangingName="ProductosRowChanging" msprop:Generator_RowEvHandlerName="ProductosRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductosRowDeleted" msprop:Generator_RowEvArgName="ProductosRowChangeEvent" msprop:Generator_RowChangedName="ProductosRowChanged" msprop:Generator_RowClassName="ProductosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CantidadEnExistencia" msprop:Generator_ColumnVarNameInTable="columnCantidadEnExistencia" msprop:Generator_ColumnPropNameInRow="CantidadEnExistencia" msprop:Generator_ColumnPropNameInTable="CantidadEnExistenciaColumn" msprop:Generator_UserColumnName="CantidadEnExistencia" type="xs:decimal" />
              <xs:element name="Minimo" msprop:Generator_ColumnVarNameInTable="columnMinimo" msprop:Generator_ColumnPropNameInRow="Minimo" msprop:Generator_ColumnPropNameInTable="MinimoColumn" msprop:Generator_UserColumnName="Minimo" type="xs:decimal" />
              <xs:element name="Maximo" msprop:Generator_ColumnVarNameInTable="columnMaximo" msprop:Generator_ColumnPropNameInRow="Maximo" msprop:Generator_ColumnPropNameInTable="MaximoColumn" msprop:Generator_UserColumnName="Maximo" type="xs:decimal" />
              <xs:element name="PrecioPorUnidad" msprop:Generator_ColumnVarNameInTable="columnPrecioPorUnidad" msprop:Generator_ColumnPropNameInRow="PrecioPorUnidad" msprop:Generator_ColumnPropNameInTable="PrecioPorUnidadColumn" msprop:Generator_UserColumnName="PrecioPorUnidad" type="xs:decimal" />
              <xs:element name="CodigoDeLaLinea" msprop:Generator_ColumnVarNameInTable="columnCodigoDeLaLinea" msprop:Generator_ColumnPropNameInRow="CodigoDeLaLinea" msprop:Generator_ColumnPropNameInTable="CodigoDeLaLineaColumn" msprop:Generator_UserColumnName="CodigoDeLaLinea">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodigoDelProveedor" msprop:Generator_ColumnVarNameInTable="columnCodigoDelProveedor" msprop:Generator_ColumnPropNameInRow="CodigoDelProveedor" msprop:Generator_ColumnPropNameInTable="CodigoDelProveedorColumn" msprop:Generator_UserColumnName="CodigoDelProveedor">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Proveedores" msprop:Generator_TableClassName="ProveedoresDataTable" msprop:Generator_TableVarName="tableProveedores" msprop:Generator_TablePropName="Proveedores" msprop:Generator_RowDeletingName="ProveedoresRowDeleting" msprop:Generator_UserTableName="Proveedores" msprop:Generator_RowChangingName="ProveedoresRowChanging" msprop:Generator_RowEvHandlerName="ProveedoresRowChangeEventHandler" msprop:Generator_RowDeletedName="ProveedoresRowDeleted" msprop:Generator_RowEvArgName="ProveedoresRowChangeEvent" msprop:Generator_RowChangedName="ProveedoresRowChanged" msprop:Generator_RowClassName="ProveedoresRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefono" msprop:Generator_ColumnVarNameInTable="columnTelefono" msprop:Generator_ColumnPropNameInRow="Telefono" msprop:Generator_ColumnPropNameInTable="TelefonoColumn" msprop:Generator_UserColumnName="Telefono" type="xs:decimal" />
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" type="xs:decimal" minOccurs="0" />
              <xs:element name="E_Mail" msprop:Generator_ColumnVarNameInTable="columnE_Mail" msprop:Generator_ColumnPropNameInRow="E_Mail" msprop:Generator_ColumnPropNameInTable="E_MailColumn" msprop:Generator_UserColumnName="E_Mail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contacto" msprop:Generator_ColumnVarNameInTable="columnContacto" msprop:Generator_ColumnPropNameInRow="Contacto" msprop:Generator_ColumnPropNameInTable="ContactoColumn" msprop:Generator_UserColumnName="Contacto">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Salidas" msprop:Generator_TableClassName="SalidasDataTable" msprop:Generator_TableVarName="tableSalidas" msprop:Generator_TablePropName="Salidas" msprop:Generator_RowDeletingName="SalidasRowDeleting" msprop:Generator_UserTableName="Salidas" msprop:Generator_RowChangingName="SalidasRowChanging" msprop:Generator_RowEvHandlerName="SalidasRowChangeEventHandler" msprop:Generator_RowDeletedName="SalidasRowDeleted" msprop:Generator_RowEvArgName="SalidasRowChangeEvent" msprop:Generator_RowChangedName="SalidasRowChanged" msprop:Generator_RowClassName="SalidasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NumeroDeFactura" msprop:Generator_ColumnVarNameInTable="columnNumeroDeFactura" msprop:Generator_ColumnPropNameInRow="NumeroDeFactura" msprop:Generator_ColumnPropNameInTable="NumeroDeFacturaColumn" msprop:Generator_UserColumnName="NumeroDeFactura" type="xs:decimal" />
              <xs:element name="CodigoDelProducto" msprop:Generator_ColumnVarNameInTable="columnCodigoDelProducto" msprop:Generator_ColumnPropNameInRow="CodigoDelProducto" msprop:Generator_ColumnPropNameInTable="CodigoDelProductoColumn" msprop:Generator_UserColumnName="CodigoDelProducto">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:decimal" />
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Usuarios" msprop:Generator_TableClassName="UsuariosDataTable" msprop:Generator_TableVarName="tableUsuarios" msprop:Generator_TablePropName="Usuarios" msprop:Generator_RowDeletingName="UsuariosRowDeleting" msprop:Generator_UserTableName="Usuarios" msprop:Generator_RowChangingName="UsuariosRowChanging" msprop:Generator_RowEvHandlerName="UsuariosRowChangeEventHandler" msprop:Generator_RowDeletedName="UsuariosRowDeleted" msprop:Generator_RowEvArgName="UsuariosRowChangeEvent" msprop:Generator_RowChangedName="UsuariosRowChanged" msprop:Generator_RowClassName="UsuariosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Usuario" msprop:Generator_ColumnVarNameInTable="columnUsuario" msprop:Generator_ColumnPropNameInRow="Usuario" msprop:Generator_ColumnPropNameInTable="UsuarioColumn" msprop:Generator_UserColumnName="Usuario">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contraseña" msprop:Generator_ColumnVarNameInTable="columnContraseña" msprop:Generator_ColumnPropNameInRow="Contraseña" msprop:Generator_ColumnPropNameInTable="ContraseñaColumn" msprop:Generator_UserColumnName="Contraseña">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Modulo" msprop:Generator_ColumnVarNameInTable="columnModulo" msprop:Generator_ColumnPropNameInRow="Modulo" msprop:Generator_ColumnPropNameInTable="ModuloColumn" msprop:Generator_UserColumnName="Modulo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Privilegio" msprop:Generator_ColumnVarNameInTable="columnPrivilegio" msprop:Generator_ColumnPropNameInRow="Privilegio" msprop:Generator_ColumnPropNameInTable="PrivilegioColumn" msprop:Generator_UserColumnName="Privilegio">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsuarioM" msprop:Generator_TableClassName="UsuarioMDataTable" msprop:Generator_TableVarName="tableUsuarioM" msprop:Generator_TablePropName="UsuarioM" msprop:Generator_RowDeletingName="UsuarioMRowDeleting" msprop:Generator_UserTableName="UsuarioM" msprop:Generator_RowChangingName="UsuarioMRowChanging" msprop:Generator_RowEvHandlerName="UsuarioMRowChangeEventHandler" msprop:Generator_RowDeletedName="UsuarioMRowDeleted" msprop:Generator_RowEvArgName="UsuarioMRowChangeEvent" msprop:Generator_RowChangedName="UsuarioMRowChanged" msprop:Generator_RowClassName="UsuarioMRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Modulo" msprop:Generator_ColumnVarNameInTable="columnModulo" msprop:Generator_ColumnPropNameInRow="Modulo" msprop:Generator_ColumnPropNameInTable="ModuloColumn" msprop:Generator_UserColumnName="Modulo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsuarioP" msprop:Generator_TableClassName="UsuarioPDataTable" msprop:Generator_TableVarName="tableUsuarioP" msprop:Generator_TablePropName="UsuarioP" msprop:Generator_RowDeletingName="UsuarioPRowDeleting" msprop:Generator_UserTableName="UsuarioP" msprop:Generator_RowChangingName="UsuarioPRowChanging" msprop:Generator_RowEvHandlerName="UsuarioPRowChangeEventHandler" msprop:Generator_RowDeletedName="UsuarioPRowDeleted" msprop:Generator_RowEvArgName="UsuarioPRowChangeEvent" msprop:Generator_RowChangedName="UsuarioPRowChanged" msprop:Generator_RowClassName="UsuarioPRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Privilegio" msprop:Generator_ColumnVarNameInTable="columnPrivilegio" msprop:Generator_ColumnPropNameInRow="Privilegio" msprop:Generator_ColumnPropNameInTable="PrivilegioColumn" msprop:Generator_UserColumnName="Privilegio">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Facturas" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="LineaDeProductos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LineaDeProductos" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="Productos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Productos" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="Proveedores_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Proveedores" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="Usuarios_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usuarios" />
      <xs:field xpath="mstns:Usuario" />
    </xs:unique>
    <xs:unique name="UsuarioM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UsuarioM" />
      <xs:field xpath="mstns:Modulo" />
    </xs:unique>
    <xs:unique name="UsuarioP_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UsuarioP" />
      <xs:field xpath="mstns:Privilegio" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Devoluciones_Productos" msdata:parent="Productos" msdata:child="Devoluciones" msdata:parentkey="Codigo" msdata:childkey="CodigoDelProducto" msprop:Generator_UserChildTable="Devoluciones" msprop:Generator_ChildPropName="GetDevolucionesRows" msprop:Generator_UserParentTable="Productos" msprop:Generator_UserRelationName="FK_Devoluciones_Productos" msprop:Generator_RelationVarName="relationFK_Devoluciones_Productos" msprop:Generator_ParentPropName="ProductosRow" />
      <msdata:Relationship name="FK_Entradas_Productos" msdata:parent="Productos" msdata:child="Entradas" msdata:parentkey="Codigo" msdata:childkey="CodigoDelProducto" msprop:Generator_UserChildTable="Entradas" msprop:Generator_ChildPropName="GetEntradasRows" msprop:Generator_UserParentTable="Productos" msprop:Generator_UserRelationName="FK_Entradas_Productos" msprop:Generator_RelationVarName="relationFK_Entradas_Productos" msprop:Generator_ParentPropName="ProductosRow" />
      <msdata:Relationship name="FK_Productos_LineaDeProductos" msdata:parent="LineaDeProductos" msdata:child="Productos" msdata:parentkey="Codigo" msdata:childkey="CodigoDeLaLinea" msprop:Generator_UserChildTable="Productos" msprop:Generator_ChildPropName="GetProductosRows" msprop:Generator_UserParentTable="LineaDeProductos" msprop:Generator_UserRelationName="FK_Productos_LineaDeProductos" msprop:Generator_RelationVarName="relationFK_Productos_LineaDeProductos" msprop:Generator_ParentPropName="LineaDeProductosRow" />
      <msdata:Relationship name="FK_Productos_Proveedores" msdata:parent="Proveedores" msdata:child="Productos" msdata:parentkey="Codigo" msdata:childkey="CodigoDelProveedor" msprop:Generator_UserChildTable="Productos" msprop:Generator_ChildPropName="GetProductosRows" msprop:Generator_UserParentTable="Proveedores" msprop:Generator_UserRelationName="FK_Productos_Proveedores" msprop:Generator_RelationVarName="relationFK_Productos_Proveedores" msprop:Generator_ParentPropName="ProveedoresRow" />
      <msdata:Relationship name="FK_Salidas_Productos" msdata:parent="Productos" msdata:child="Salidas" msdata:parentkey="Codigo" msdata:childkey="CodigoDelProducto" msprop:Generator_UserChildTable="Salidas" msprop:Generator_ChildPropName="GetSalidasRows" msprop:Generator_UserParentTable="Productos" msprop:Generator_UserRelationName="FK_Salidas_Productos" msprop:Generator_RelationVarName="relationFK_Salidas_Productos" msprop:Generator_ParentPropName="ProductosRow" />
      <msdata:Relationship name="FK_Usuarios_UsuarioM" msdata:parent="UsuarioM" msdata:child="Usuarios" msdata:parentkey="Modulo" msdata:childkey="Modulo" msprop:Generator_UserChildTable="Usuarios" msprop:Generator_ChildPropName="GetUsuariosRows" msprop:Generator_ParentPropName="UsuarioMRow" msprop:Generator_UserRelationName="FK_Usuarios_UsuarioM" msprop:Generator_RelationVarName="relationFK_Usuarios_UsuarioM" msprop:Generator_UserParentTable="UsuarioM" />
      <msdata:Relationship name="FK_Usuarios_UsuarioP" msdata:parent="UsuarioP" msdata:child="Usuarios" msdata:parentkey="Privilegio" msdata:childkey="Privilegio" msprop:Generator_UserChildTable="Usuarios" msprop:Generator_ChildPropName="GetUsuariosRows" msprop:Generator_ParentPropName="UsuarioPRow" msprop:Generator_UserRelationName="FK_Usuarios_UsuarioP" msprop:Generator_RelationVarName="relationFK_Usuarios_UsuarioP" msprop:Generator_UserParentTable="UsuarioP" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>